About the toolbar, field list, and Commands and Options dialog box

The toolbar in a PivotTable list appears at the top of the list and provides a set of commands that you can use to work with the data in the PivotTable list while you are designing it.

In the browser, users can also use the toolbar to work with the PivotTable list. Rest the pointer on each toolbar button to display the name of its command.

If you don't want users to have access to the toolbar in the browser, you can hide the toolbar. To ensure that users cannot redisplay the toolbar, you must restrict access to the Commands and Options dialog box, hide shortcut menus by writing script, and hide the title bar.

Use the field list to view the fieldsets and fields that are available from the source data and to add fields to the row, column, filter, data, and detail areas of the PivotTable list. You can scroll and click the expand indicators ( or boxes) next to a fieldset to show or hide fields. In the field list, the fields that are not bold are available but not yet displayed in the PivotTable list. The bold fields are already displayed.

Use this dialog box to do common tasks, such as filtering data, formatting text, and showing or hiding elements. The tabs displayed in the dialog box change as you select different parts of a PivotTable list. If you select a control on the Web page other than a PivotTable list or other Microsoft Office Web Component, the dialog box is hidden until you activate the component again.

The Commands and Options dialog box includes some commands that aren't present on the toolbar or shortcut menus. Some properties and commands are available in the Commands and Options dialog box both when you are designing the PivotTable list and when it's displayed in the browser. Others are available only when you are working in a design program. If you don't want users to have access to the commands and property settings in the Commands and Options dialog box, you can make the dialog box unavailable in the browser.